UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a9pb78xJtmE3Yzf84VPAvfz6cYfuJ1U4qrb0XuvK0wg='
WHERE
key_id = 'f1cf82f3b82630f242380451a61f4eb0e5bf019c82aded511fccdec673ab8006'
AND (
token = 'a9pb78xJtmE3Yzf84VPAvfz6cYfuJ1U4qrb0XuvK0wg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)