UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hCZ8rP1gf+AtYaKBeUiaasIvfPiux39zn3tVEgy19sM='
WHERE
key_id = 'b37ba9b5a451f686e7ac52155aa97d5521383722b9459e4cb817dd4a834ad08e'
AND (
token = 'hCZ8rP1gf+AtYaKBeUiaasIvfPiux39zn3tVEgy19sM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)