UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gTD9PlJ3uXJwHowcdY1PR0shfwjBKv8fymik2A060CU='
WHERE
key_id = '20bc3718ace21819ba63822b069e8d38c116a9052ec92d1b48a189dd81ca4b14'
AND (
token = 'gTD9PlJ3uXJwHowcdY1PR0shfwjBKv8fymik2A060CU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)