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