UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3gTh7shSyTTAHZ/1zkmBBfVUhhuPRIRWM/NSiqApgbA='
WHERE
key_id = 'b5e53e91d286866df4c6010b89e0b84b06211dec7ec548c4feac543a2018b195'
AND (
token = '3gTh7shSyTTAHZ/1zkmBBfVUhhuPRIRWM/NSiqApgbA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)