UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0qr1MMs4VVtBXlxX6KMZblPb1zH9E9wM20QRHm527G4='
WHERE
key_id = 'f71dcec13b21c95c0c129833edb9a45b3f8a5e19a9a616a4ad7bdd866bc6cb6a'
AND (
token = '0qr1MMs4VVtBXlxX6KMZblPb1zH9E9wM20QRHm527G4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)