UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YOohxI6JKcTc7OYtaV24t8I6BthS5gekYH8NqmpJugc='
WHERE
key_id = '55a4dd3bb24267b832227e1f00e9a31d740e23603a4a37ff90f83ba8ec77806c'
AND (
token = 'YOohxI6JKcTc7OYtaV24t8I6BthS5gekYH8NqmpJugc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)