UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'FRyH1Drmr/n6YV3hgoPfZQ9yABYg+tX4xEzxJ2McBu8=' 
WHERE 
  key_id = 'f5bb5ada69fbe369b2571a5624de0a083b39557ad0b2939898d6c5d36b258ace' 
  AND (
    token = 'FRyH1Drmr/n6YV3hgoPfZQ9yABYg+tX4xEzxJ2McBu8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047