UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lTjf6s+iHHMqsc1YCEFeVTU6u3k/X/aTy06USaZpiuk='
WHERE
key_id = 'aa49a2580fbe84f0fb193d7ad87155f5ce6c2b0dddf2f8826d9a760091720932'
AND (
token = 'lTjf6s+iHHMqsc1YCEFeVTU6u3k/X/aTy06USaZpiuk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)