UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hLIfDUJ29Ddb31ohIc6Pu6NZcw6Dis8E5k6bxZ5ija0='
WHERE
key_id = '7e24e49ae0370966617a26c85e01f24cde467fa1706be7c0deb191f0a2ee3295'
AND (
token = 'hLIfDUJ29Ddb31ohIc6Pu6NZcw6Dis8E5k6bxZ5ija0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)