UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7Yi8P7ZcS0feYFT/semnkVd5C/ZStInBJlYKrz/GFWY='
WHERE
key_id = '6f117133a18237a14a08dd254b30429ab4c26a627f3790b19b8e25c3ac60f3a2'
AND (
token = '7Yi8P7ZcS0feYFT/semnkVd5C/ZStInBJlYKrz/GFWY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)