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