UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Gh12JrzXr9soIY6Nq1Ln6w31tAESjE9J99UiRdNwjl4='
WHERE
key_id = '1695c4f1bb744b5049267a2cf9894d7d26394c73f85b7db07a7489d797b1eb04'
AND (
token = 'Gh12JrzXr9soIY6Nq1Ln6w31tAESjE9J99UiRdNwjl4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)