UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A4rIAbFJFjSx4fsMvmVi7VWivODJOmv7scA3bTTjCYw='
WHERE
key_id = '6f54d436c7d0c86be173353d9e2e35afde1dfe57b5524294c21a521de410f33a'
AND (
token = 'A4rIAbFJFjSx4fsMvmVi7VWivODJOmv7scA3bTTjCYw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)