UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pnOMkOTFcqBPgXxdsdJpTBV7lINKLQSxDb1y1iAvFjY='
WHERE
key_id = 'ba8f27764c6cd54c758e8916fc5e14b69117667fb3b3abd4bc9f18fc60e62958'
AND (
token = 'pnOMkOTFcqBPgXxdsdJpTBV7lINKLQSxDb1y1iAvFjY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)