UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RVkzpZLKvXxQTDt4WziOvGIFscknkGyVgz/poxfKCjM='
WHERE
key_id = 'e2121297dd385f6a7f5635bb032d34f9aaaddb3f4f378d1c16879299ae27f812'
AND (
token = 'RVkzpZLKvXxQTDt4WziOvGIFscknkGyVgz/poxfKCjM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)