UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+s8auNLsiozg31KCwlowDcNBnMwb/PK9gu27yoNQejE='
WHERE
key_id = 'b4e6217deeee8a1c538fa4b67e77d4b5caf2419bc43e657f364fc7ab5fe224ab'
AND (
token = '+s8auNLsiozg31KCwlowDcNBnMwb/PK9gu27yoNQejE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)