UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OtGYrg44cl2qHg3JLYJUGvbwEFYCRKE6KNiLSDM/+LU='
WHERE
key_id = 'ad9d98f43b6ce361d991a2aa21f8ab3dc92dff77176b652035168e292730c185'
AND (
token = 'OtGYrg44cl2qHg3JLYJUGvbwEFYCRKE6KNiLSDM/+LU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)