UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+bKFt3aM1n4MRr9F03HDI2tEvJFDuLAazZOj+nyXmJg=' 
WHERE 
  key_id = 'c6835ebeafca2fe219c135d87c001cb2bca57be6e64149ee50ef4bc6d300f2bc' 
  AND (
    token = '+bKFt3aM1n4MRr9F03HDI2tEvJFDuLAazZOj+nyXmJg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030