UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sU7hF5DPREfRK1A8ysV1rf1c2C7wkJu61miYy9IK7/Y='
WHERE
key_id = '38f52a4cf31965eafb8075904f204b8abc92082ed70296fabeb8617671ef0d4a'
AND (
token = 'sU7hF5DPREfRK1A8ysV1rf1c2C7wkJu61miYy9IK7/Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)