UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Oiv6dhTLv4KZ7vC8yAyZ1QtJuVU9owOJHyIFP4JC45w='
WHERE
key_id = '547c3b32c19fe089731851dc9e7824740d55b615ec0b6594d5aef2c5045ae360'
AND (
token = 'Oiv6dhTLv4KZ7vC8yAyZ1QtJuVU9owOJHyIFP4JC45w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)