UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0nx38UAil9nkeu/FxpVymp3iizdwPEpTo3K8Sfid/Jw='
WHERE
key_id = 'b341806f929be72b3c3644c0e944e1c189c73663ba8b7e6526b0688b1e82910d'
AND (
token = '0nx38UAil9nkeu/FxpVymp3iizdwPEpTo3K8Sfid/Jw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)