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