UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ZLY8CpA7tRnaWVdTYLRu2O+cfV0cV5aWtWcfbaN3B9U=' 
WHERE 
  key_id = 'b05ca04aa6d318d56e3b80fcf2747ec2c5a51ed2761f12d3c79ed4c057a94f10' 
  AND (
    token = 'ZLY8CpA7tRnaWVdTYLRu2O+cfV0cV5aWtWcfbaN3B9U=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00054