UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'qTpNO8bWJm0QzPg5naukey40V7cdFLlM9ZAPqxUhLNg=' 
WHERE 
  key_id = 'dc889796c08d47cc19f1bcc8d5f86c9a563f39653eb9a41a40e802957c0f6d9d' 
  AND (
    token = 'qTpNO8bWJm0QzPg5naukey40V7cdFLlM9ZAPqxUhLNg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037