UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6XunB4HIB85D9h0NHXBtAx35SnXg2KikDHtHXmx8Fpw='
WHERE
key_id = 'deb9d5c30f8e16d8d6f58731fb288104f2eddf1a7a5293c5fb87cc54b8ac39e0'
AND (
token = '6XunB4HIB85D9h0NHXBtAx35SnXg2KikDHtHXmx8Fpw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)