UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oXVTi3M0oqiSpp41uOvsDpnepXQbPPfyIa3r62smsp0='
WHERE
key_id = '56557e0291b2d11f277589fd685f4dce5f0cc6fa724e8d1012ae3c87602725a4'
AND (
token = 'oXVTi3M0oqiSpp41uOvsDpnepXQbPPfyIa3r62smsp0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)