UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CKpYzu0lhX3KSCdFzSOSqjKz+B20RJxcsPmU88dPOyc='
WHERE
key_id = 'dc8fb6528b96fd20b8452a261f7c6ecd486fee8369091229859a0b69859c7d2a'
AND (
token = 'CKpYzu0lhX3KSCdFzSOSqjKz+B20RJxcsPmU88dPOyc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)