UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'F/KpXOCGJXwAhdNweSOeiao0WV61I00QdXIa3gLzygk='
WHERE
key_id = 'ef2d815feac505164e5673453ad1bfa4fcf1ba29334c5aba13d05bb6abdd8fc3'
AND (
token = 'F/KpXOCGJXwAhdNweSOeiao0WV61I00QdXIa3gLzygk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)