UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JXCbNpVM5PeYWRzYk9GpeE2W8VnoTS7Wu15j7CfDaaY='
WHERE
key_id = '9aa4adf3e9e366fb84d8d4e8eab87c52e3228f18deaa8b60f0e7e068d8adbde7'
AND (
token = 'JXCbNpVM5PeYWRzYk9GpeE2W8VnoTS7Wu15j7CfDaaY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)