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