UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D7V6Om9VeAhvuKYS3zJVibkNAqI15k0nGEoqoSj7ZMw='
WHERE
key_id = '6078cbb9fd1350de8905a718cee701a934c8ed8332309b845e3383b197e2d18b'
AND (
token = 'D7V6Om9VeAhvuKYS3zJVibkNAqI15k0nGEoqoSj7ZMw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)