UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gFkpz4Q4t235lO17bT42fdJCA1tIDmRM++tqKr4dyIE='
WHERE
key_id = '1bc4e49928aa0e9830bcf1e9d5235ad8b8e5c1fa83b54dd5d9f49927e10bf3ba'
AND (
token = 'gFkpz4Q4t235lO17bT42fdJCA1tIDmRM++tqKr4dyIE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)