UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '7i+HUMT1DVUYy2TjFT8yFeAWRHOlalwaPCn7Gy6Ku70=' 
WHERE 
  key_id = '4952835bea54d8122339ccab6e84c45714b9e2ae76ff0c123c567b7e0e0a0fd0' 
  AND (
    token = '7i+HUMT1DVUYy2TjFT8yFeAWRHOlalwaPCn7Gy6Ku70=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041