UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wqp3oiU9QCqHEDM5spdghHopLHaxyG3Q43slpyYbEh4='
WHERE
key_id = 'e2aebcaf02f4a68c4934370eb1edfbf9c07cdc848cacc6feeff8c7f55ff6f199'
AND (
token = 'wqp3oiU9QCqHEDM5spdghHopLHaxyG3Q43slpyYbEh4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)