UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zIiDKBMtoU2w5pa7J9zRC23mNG/NHMvtIovvE9h5qNw='
WHERE
key_id = '38a642aeb5920bcf0f98a865bd371468af2ed6da389e1b1395987abfa2981738'
AND (
token = 'zIiDKBMtoU2w5pa7J9zRC23mNG/NHMvtIovvE9h5qNw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)