UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AfNGo9hYzACAeRAS1eJ3WxZzwRzplHcI1x6q07ZrR6Q='
WHERE
key_id = 'af9b36477bc3c85952b25aa8dbef29c27d7eaa9c5ae9f4e5e3de1a1c0065f1b6'
AND (
token = 'AfNGo9hYzACAeRAS1eJ3WxZzwRzplHcI1x6q07ZrR6Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)